<?php

//use Illuminate\Support\Facades\Schema;
use Jialeo\LaravelSchemaExtend\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateShopSitesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('shop_sites', function (Blueprint $table) {
            $table->comment = '地址管理表';
            $table->increments('id')->comment('地址ID');
			$table->integer('user_id')->comment('用户ID');
            $table->string('name',50)->default('')->comment('姓名');
            $table->string('phone',30)->default('')->comment('手机号');
            $table->integer('province_id')->comment('省ID');
            $table->integer('city_id')->comment('市ID');
            $table->integer('county_id')->comment('区/县ID');
			$table->string('detailed_address',100)->default('')->comment('详细地址');
            $table->tinyInteger('status')->default(1)->comment('是否默认：1=是 0=否');
            $table->timestamps(); 
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('shop_sites');
    }
}
